Tabela LSubBenefitPlanContract

Definicja tabeli LSubBenefitPlanContract

Name

LSubBenefitPlanContract

Code

LSubBenefitPlanContract

Comment

Podlegle benefitplany, np. dla rodziny w ramach kontraktu

SuperBenefitplan moze zawierac subbenefitplany tylko wówczas gdy ma Status Beneficjenta jest pracownik


Lista kolumn tabeli LSubBenefitPlanContract

Name

Code

Ben_BenefitPlanContractID

Ben_BenefitPlanContractID

BenefitPlanContractID

BenefitPlanContractID


Kolumna Ben_BenefitPlanContractID tabeli LSubBenefitPlanContract

Definicja kolumny Ben_BenefitPlanContractID tabeli LSubBenefitPlanContract

Name

Ben_BenefitPlanContractID

Code

Ben_BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BenefitPlanContractID tabeli LSubBenefitPlanContract

Definicja kolumny BenefitPlanContractID tabeli LSubBenefitPlanContract

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LSubBenefitPlanContract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LSubBenefitPlanContract

Definicja klucza Identifier_1 tabeli LSubBenefitPlanContract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment